This article is a comparison of
data modeling
Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. It may be applied as part of broader Model-driven engineering (MDE) concept.
Overview
Data modeli ...
tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.
General
Features
{, class="sortable wikitable" style="width: auto; text-align: center;"
! Tool
! Supported data models (conceptual, logical, physical)
! Supported notations
! Forward engineering
! Reverse engineering
! Model/database comparison and synchronization
! Teamwork/repository
, -
,
Database Workbench
, Conceptual, logical, physical
,
IE (Crow’s foot)
,
,
, Update database and/or update model
,
, -
,
Enterprise Architect
Enterprise architecture (EA) is a business function concerned with the structures and behaviours of a business, especially business roles and processes that create and use business data. The international definition according to the Federation of ...
, Conceptual, Logical & Physical + MDA Transform of Logical to Physical
,
IDEF1X
Integration DEFinition for information modeling (IDEF1X) is a data modeling language for the development of semantic data models. IDEF1X is used to produce a graphical information model which represents the structure and semantics of informatio ...
,
UML DDL, Information Engineering &
ERD
,
,
, Update database and/or update model
, Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge).
, -
,
ER/Studio
ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 201 ...
, Logical, physical, ETL
, IDEF1X, IE (Crow’s feet)
,
,
, Update database and/or update model
, ER/Studio Repository and Team Server (formerly Portal/CONNECT) for web based publishing collaboration and model management, with Business Glossary as standard.
, -
,
MagicDraw
MagicDraw is a proprietary visual UML, SysML, BPMN, and UPDM modeling tool with team collaboration support.
Features Domain specific language
The domain specific language (DSL) customization engine allows for adapting MagicDraw to a specifi ...
, Conceptual, Logical & Physical + MDA Transform of Logical to Physical
, IDEF1X, UML DDL, Information Engineering & ERD
,
,
, Update database and/or update model
, Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge).
, -
,
MySQL Workbench
, Physical
, IDEF1X, IE (Crow’s feet), UML, and more
,
,
, Update database and/or update model
,
, -
,
Navicat
Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL, Microsoft SQL Server and Snowflake. It has an Explorer-like graphical user ...
Data Modeler
, Conceptual, Logical & Physical
, IE (Crow’s foot)
,
,
, Update database and/or update model
,
, -
,
NORMA Norma may refer to:
* Norma (given name), a given name (including a list of people with the name)
** Norma Lizbeth Ramos, a Mexican bullying victim
Astronomy
*Norma (constellation)
* 555 Norma, a minor asteroid
* Cygnus Arm or Norma Arm, a spiral ...
Object-Role modeling
, Conceptual (ORM), Logical, Physical
, ORM, Relational(Crow’s foot option), Barker
,
,
, Update database and/or update model
,
, -
,
Open ModelSphere
, Conceptual, Logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
,
, -
,
Oracle SQL Developer
Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.
Features
Oracle SQL Developer supports Oracle prod ...
Data Modeler
, Logical, physical
, Barker, IE (Crow’s foot), and Bachman
,
,
, Update database and/or update model
,
, -
,
PowerDesigner
, Conceptual, logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
,
, -
,
Software Ideas Modeler
, Conceptual, logical, physical
, IDEF1X, IE (Crow’s foot), UML and more
,
,
, Update database and/or update model
,
, -
,
Toad Data Modeler
, Logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
, {{yes
See also
*
Comparison of database administration tools
*
List of Unified Modeling Language tools
This article compares UML tools. UML tools are software applications which support some functions of the Unified Modeling Language.
General
Features
See also
* List of requirements engineering tools
References
External links
*
Data modeling
Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. It may be applied as part of broader Model-driven engineering (MDE) concept.
Overview
Data modeli ...
*
IDEF1X
Integration DEFinition for information modeling (IDEF1X) is a data modeling language for the development of semantic data models. IDEF1X is used to produce a graphical information model which represents the structure and semantics of informatio ...
D